Overview
Brought to you by YData
Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 500 |
| Missing cells | 1946 |
| Missing cells (%) | 13.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 672.3 KiB |
| Average record size in memory | 1.3 KiB |
Variable types
| Text | 4 |
|---|---|
| Categorical | 19 |
| Numeric | 4 |
| DateTime | 2 |
capacity_kg is highly overall correlated with product_category | High correlation |
capacity_liters is highly overall correlated with product_category and 1 other fields | High correlation |
capacity_place_settings is highly overall correlated with product_category and 1 other fields | High correlation |
capacity_tons is highly overall correlated with product_category | High correlation |
feature_1 is highly overall correlated with product_category and 2 other fields | High correlation |
product_category is highly overall correlated with capacity_kg and 6 other fields | High correlation |
sub_type is highly overall correlated with feature_1 and 2 other fields | High correlation |
technology is highly overall correlated with capacity_liters and 4 other fields | High correlation |
warranty_duration_months is highly overall correlated with warranty_years | High correlation |
warranty_years is highly overall correlated with warranty_duration_months | High correlation |
product_id has 15 (3.0%) missing values | Missing |
product_category has 15 (3.0%) missing values | Missing |
sub_type has 15 (3.0%) missing values | Missing |
model_name has 15 (3.0%) missing values | Missing |
capacity_tons has 423 (84.6%) missing values | Missing |
capacity_liters has 247 (49.4%) missing values | Missing |
capacity_kg has 423 (84.6%) missing values | Missing |
capacity_place_settings has 418 (83.6%) missing values | Missing |
technology has 15 (3.0%) missing values | Missing |
feature_1 has 15 (3.0%) missing values | Missing |
energy_rating_stars has 90 (18.0%) missing values | Missing |
color has 15 (3.0%) missing values | Missing |
price_inr has 15 (3.0%) missing values | Missing |
manufacturing_date has 15 (3.0%) missing values | Missing |
warranty_years has 15 (3.0%) missing values | Missing |
customer_rating has 15 (3.0%) missing values | Missing |
city has 15 (3.0%) missing values | Missing |
platform has 15 (3.0%) missing values | Missing |
discount_offered has 15 (3.0%) missing values | Missing |
availability has 15 (3.0%) missing values | Missing |
warranty_duration_months has 15 (3.0%) missing values | Missing |
review_sentiment has 15 (3.0%) missing values | Missing |
return_status has 15 (3.0%) missing values | Missing |
complaint_text has 15 (3.0%) missing values | Missing |
resolved_status has 15 (3.0%) missing values | Missing |
review_date has 15 (3.0%) missing values | Missing |
reviewer_location has 15 (3.0%) missing values | Missing |
product_name has 15 (3.0%) missing values | Missing |
discount_offered has 63 (12.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-08-19 01:02:56.233877 |
|---|---|
| Analysis finished | 2025-08-19 01:03:02.286484 |
| Duration | 6.05 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
product_id
Text
Missing
| Distinct | 484 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 31.9 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 483 ? |
|---|---|
| Unique (%) | 99.6% |
Sample
| 1st row | PID433097 |
|---|---|
| 2nd row | PID251899 |
| 3rd row | PID857398 |
| 4th row | PID934528 |
| 5th row | PID952837 |
| Value | Count | Frequency (%) |
| pid514014 | 2 | 0.4% |
| pid947406 | 1 | 0.2% |
| pid853697 | 1 | 0.2% |
| pid587371 | 1 | 0.2% |
| pid552702 | 1 | 0.2% |
| pid937912 | 1 | 0.2% |
| pid952837 | 1 | 0.2% |
| pid651778 | 1 | 0.2% |
| pid796565 | 1 | 0.2% |
| pid623558 | 1 | 0.2% |
| Other values (474) | 474 |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 485 | |
| I | 485 | |
| D | 485 | |
| 3 | 327 | |
| 2 | 309 | 7.1% |
| 4 | 300 | 6.9% |
| 6 | 299 | 6.8% |
| 8 | 295 | 6.8% |
| 9 | 288 | 6.6% |
| 5 | 286 | 6.6% |
| Other values (3) | 806 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4365 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 485 | |
| I | 485 | |
| D | 485 | |
| 3 | 327 | |
| 2 | 309 | 7.1% |
| 4 | 300 | 6.9% |
| 6 | 299 | 6.8% |
| 8 | 295 | 6.8% |
| 9 | 288 | 6.6% |
| 5 | 286 | 6.6% |
| Other values (3) | 806 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4365 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 485 | |
| I | 485 | |
| D | 485 | |
| 3 | 327 | |
| 2 | 309 | 7.1% |
| 4 | 300 | 6.9% |
| 6 | 299 | 6.8% |
| 8 | 295 | 6.8% |
| 9 | 288 | 6.6% |
| 5 | 286 | 6.6% |
| Other values (3) | 806 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4365 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 485 | |
| I | 485 | |
| D | 485 | |
| 3 | 327 | |
| 2 | 309 | 7.1% |
| 4 | 300 | 6.9% |
| 6 | 299 | 6.8% |
| 8 | 295 | 6.8% |
| 9 | 288 | 6.6% |
| 5 | 286 | 6.6% |
| Other values (3) | 806 |
product_category
Categorical
High correlation Missing
| Distinct | 6 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 34.1 KiB |
| Refrigerator | |
|---|---|
| Dishwasher | |
| Water Dispenser | |
| Air Cooler | |
| Washing Machine |
Length
| Max length | 15 |
|---|---|
| Median length | 12 |
| Mean length | 12.795876 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Dishwasher |
|---|---|
| 2nd row | Washing Machine |
| 3rd row | Air Conditioner |
| 4th row | Air Conditioner |
| 5th row | Air Conditioner |
Common Values
| Value | Count | Frequency (%) |
| Refrigerator | 88 | |
| Dishwasher | 83 | |
| Water Dispenser | 82 | |
| Air Cooler | 78 | |
| Washing Machine | 78 | |
| Air Conditioner | 76 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| air | 154 | |
| refrigerator | 88 | |
| dishwasher | 83 | |
| water | 82 | |
| dispenser | 82 | |
| cooler | 78 | |
| washing | 78 | |
| machine | 78 | |
| conditioner | 76 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 819 | |
| e | 737 | |
| i | 715 | |
| a | 409 | 6.6% |
| s | 408 | 6.6% |
| o | 396 | 6.4% |
| n | 390 | 6.3% |
| h | 322 | 5.2% |
| 314 | 5.1% | |
| t | 246 | 4.0% |
| Other values (13) | 1450 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6206 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 819 | |
| e | 737 | |
| i | 715 | |
| a | 409 | 6.6% |
| s | 408 | 6.6% |
| o | 396 | 6.4% |
| n | 390 | 6.3% |
| h | 322 | 5.2% |
| 314 | 5.1% | |
| t | 246 | 4.0% |
| Other values (13) | 1450 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6206 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 819 | |
| e | 737 | |
| i | 715 | |
| a | 409 | 6.6% |
| s | 408 | 6.6% |
| o | 396 | 6.4% |
| n | 390 | 6.3% |
| h | 322 | 5.2% |
| 314 | 5.1% | |
| t | 246 | 4.0% |
| Other values (13) | 1450 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6206 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 819 | |
| e | 737 | |
| i | 715 | |
| a | 409 | 6.6% |
| s | 408 | 6.6% |
| o | 396 | 6.4% |
| n | 390 | 6.3% |
| h | 322 | 5.2% |
| 314 | 5.1% | |
| t | 246 | 4.0% |
| Other values (13) | 1450 |
sub_type
Categorical
High correlation Missing
| Distinct | 15 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 32.7 KiB |
| Bottom Loading | |
|---|---|
| Top Load | |
| Full Size | |
| Table Top | |
| Top Loading | |
| Other values (10) |
Length
| Max length | 14 |
|---|---|
| Median length | 11 |
| Mean length | 9.7051546 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Table Top |
|---|---|
| 2nd row | Top Load |
| 3rd row | Inverter AC |
| 4th row | Window AC |
| 5th row | Split AC |
Common Values
| Value | Count | Frequency (%) |
| Bottom Loading | 46 | 9.2% |
| Top Load | 44 | 8.8% |
| Full Size | 42 | 8.4% |
| Table Top | 39 | 7.8% |
| Top Loading | 38 | 7.6% |
| Front Load | 33 | 6.6% |
| Personal | 31 | 6.2% |
| Desert | 31 | 6.2% |
| Side-by-Side | 30 | 6.0% |
| Double Door | 30 | 6.0% |
| Other values (5) | 121 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| top | 121 | |
| loading | 84 | 9.8% |
| load | 77 | 8.9% |
| ac | 76 | 8.8% |
| door | 58 | 6.7% |
| bottom | 46 | 5.3% |
| full | 42 | 4.9% |
| size | 42 | 4.9% |
| table | 39 | 4.5% |
| front | 33 | 3.8% |
| Other values (9) | 243 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 626 | 13.3% |
| 376 | 8.0% | |
| e | 365 | 7.8% |
| i | 262 | 5.6% |
| d | 246 | 5.2% |
| l | 235 | 5.0% |
| a | 231 | 4.9% |
| n | 229 | 4.9% |
| r | 226 | 4.8% |
| t | 207 | 4.4% |
| Other values (22) | 1704 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4707 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 626 | 13.3% |
| 376 | 8.0% | |
| e | 365 | 7.8% |
| i | 262 | 5.6% |
| d | 246 | 5.2% |
| l | 235 | 5.0% |
| a | 231 | 4.9% |
| n | 229 | 4.9% |
| r | 226 | 4.8% |
| t | 207 | 4.4% |
| Other values (22) | 1704 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4707 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 626 | 13.3% |
| 376 | 8.0% | |
| e | 365 | 7.8% |
| i | 262 | 5.6% |
| d | 246 | 5.2% |
| l | 235 | 5.0% |
| a | 231 | 4.9% |
| n | 229 | 4.9% |
| r | 226 | 4.8% |
| t | 207 | 4.4% |
| Other values (22) | 1704 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4707 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 626 | 13.3% |
| 376 | 8.0% | |
| e | 365 | 7.8% |
| i | 262 | 5.6% |
| d | 246 | 5.2% |
| l | 235 | 5.0% |
| a | 231 | 4.9% |
| n | 229 | 4.9% |
| r | 226 | 4.8% |
| t | 207 | 4.4% |
| Other values (22) | 1704 |
model_name
Text
Missing
| Distinct | 485 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 32.2 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.7793814 |
| Min length | 8 |
Unique
| Unique | 485 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Model_N299 |
|---|---|
| 2nd row | Model_K244 |
| 3rd row | Model_X75 |
| 4th row | Model_X101 |
| 5th row | Model_Y128 |
| Value | Count | Frequency (%) |
| model_z233 | 1 | 0.2% |
| model_e498 | 1 | 0.2% |
| model_s460 | 1 | 0.2% |
| model_k218 | 1 | 0.2% |
| model_b469 | 1 | 0.2% |
| model_n65 | 1 | 0.2% |
| model_j217 | 1 | 0.2% |
| model_r459 | 1 | 0.2% |
| model_o274 | 1 | 0.2% |
| model_s486 | 1 | 0.2% |
| Other values (475) | 475 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 504 | |
| o | 485 | |
| d | 485 | |
| e | 485 | |
| l | 485 | |
| _ | 485 | |
| 1 | 198 | 4.2% |
| 2 | 195 | 4.1% |
| 3 | 191 | 4.0% |
| 4 | 190 | 4.0% |
| Other values (31) | 1040 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4743 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| M | 504 | |
| o | 485 | |
| d | 485 | |
| e | 485 | |
| l | 485 | |
| _ | 485 | |
| 1 | 198 | 4.2% |
| 2 | 195 | 4.1% |
| 3 | 191 | 4.0% |
| 4 | 190 | 4.0% |
| Other values (31) | 1040 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4743 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| M | 504 | |
| o | 485 | |
| d | 485 | |
| e | 485 | |
| l | 485 | |
| _ | 485 | |
| 1 | 198 | 4.2% |
| 2 | 195 | 4.1% |
| 3 | 191 | 4.0% |
| 4 | 190 | 4.0% |
| Other values (31) | 1040 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4743 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| M | 504 | |
| o | 485 | |
| d | 485 | |
| e | 485 | |
| l | 485 | |
| _ | 485 | |
| 1 | 198 | 4.2% |
| 2 | 195 | 4.1% |
| 3 | 191 | 4.0% |
| 4 | 190 | 4.0% |
| Other values (31) | 1040 |
capacity_tons
Categorical
High correlation Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 423 |
| Missing (%) | 84.6% |
| Memory size | 31.1 KiB |
| 1.5 | |
|---|---|
| 2.0 | |
| 1.2 | |
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.5 |
Common Values
| Value | Count | Frequency (%) |
| 1.5 | 26 | 5.2% |
| 2.0 | 18 | 3.6% |
| 1.2 | 17 | 3.4% |
| 1.0 | 16 | 3.2% |
| (Missing) | 423 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.5 | 26 | |
| 2.0 | 18 | |
| 1.2 | 17 | |
| 1.0 | 16 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 77 | |
| 1 | 59 | |
| 2 | 35 | |
| 0 | 34 | |
| 5 | 26 | 11.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 231 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 77 | |
| 1 | 59 | |
| 2 | 35 | |
| 0 | 34 | |
| 5 | 26 | 11.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 231 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 77 | |
| 1 | 59 | |
| 2 | 35 | |
| 0 | 34 | |
| 5 | 26 | 11.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 231 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 77 | |
| 1 | 59 | |
| 2 | 35 | |
| 0 | 34 | |
| 5 | 26 | 11.3% |
capacity_liters
Real number (ℝ)
High correlation Missing
| Distinct | 10 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 247 |
| Missing (%) | 49.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 153.16206 |
| Minimum | 15 |
|---|---|
| Maximum | 550 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 15 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 20 |
| median | 50 |
| Q3 | 250 |
| 95-th percentile | 550 |
| Maximum | 550 |
| Range | 535 |
| Interquartile range (IQR) | 230 |
Descriptive statistics
| Standard deviation | 180.98847 |
|---|---|
| Coefficient of variation (CV) | 1.1816796 |
| Kurtosis | -0.14333813 |
| Mean | 153.16206 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | 1.1452337 |
| Sum | 38750 |
| Variance | 32756.827 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 20 | 61 | 12.2% |
| 15 | 46 | 9.2% |
| 50 | 25 | 5.0% |
| 250 | 24 | 4.8% |
| 550 | 23 | 4.6% |
| 450 | 17 | 3.4% |
| 90 | 17 | 3.4% |
| 70 | 15 | 3.0% |
| 350 | 13 | 2.6% |
| 180 | 12 | 2.4% |
| (Missing) | 247 |
| Value | Count | Frequency (%) |
| 15 | 46 | |
| 20 | 61 | |
| 50 | 25 | |
| 70 | 15 | 3.0% |
| 90 | 17 | 3.4% |
| 180 | 12 | 2.4% |
| 250 | 24 | 4.8% |
| 350 | 13 | 2.6% |
| 450 | 17 | 3.4% |
| 550 | 23 | 4.6% |
| Value | Count | Frequency (%) |
| 550 | 23 | 4.6% |
| 450 | 17 | 3.4% |
| 350 | 13 | 2.6% |
| 250 | 24 | 4.8% |
| 180 | 12 | 2.4% |
| 90 | 17 | 3.4% |
| 70 | 15 | 3.0% |
| 50 | 25 | |
| 20 | 61 | |
| 15 | 46 |
capacity_kg
Categorical
High correlation Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | 6.5% |
| Missing | 423 |
| Missing (%) | 84.6% |
| Memory size | 31.1 KiB |
| 7.0 | |
|---|---|
| 6.5 | |
| 8.0 | |
| 9.0 | |
| 6.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 6.5 |
|---|---|
| 2nd row | 6.5 |
| 3rd row | 9.0 |
| 4th row | 6.5 |
| 5th row | 8.0 |
Common Values
| Value | Count | Frequency (%) |
| 7.0 | 20 | 4.0% |
| 6.5 | 19 | 3.8% |
| 8.0 | 16 | 3.2% |
| 9.0 | 12 | 2.4% |
| 6.0 | 10 | 2.0% |
| (Missing) | 423 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 7.0 | 20 | |
| 6.5 | 19 | |
| 8.0 | 16 | |
| 9.0 | 12 | |
| 6.0 | 10 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 77 | |
| 0 | 58 | |
| 6 | 29 | 12.6% |
| 7 | 20 | 8.7% |
| 5 | 19 | 8.2% |
| 8 | 16 | 6.9% |
| 9 | 12 | 5.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 231 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 77 | |
| 0 | 58 | |
| 6 | 29 | 12.6% |
| 7 | 20 | 8.7% |
| 5 | 19 | 8.2% |
| 8 | 16 | 6.9% |
| 9 | 12 | 5.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 231 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 77 | |
| 0 | 58 | |
| 6 | 29 | 12.6% |
| 7 | 20 | 8.7% |
| 5 | 19 | 8.2% |
| 8 | 16 | 6.9% |
| 9 | 12 | 5.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 231 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 77 | |
| 0 | 58 | |
| 6 | 29 | 12.6% |
| 7 | 20 | 8.7% |
| 5 | 19 | 8.2% |
| 8 | 16 | 6.9% |
| 9 | 12 | 5.2% |
capacity_place_settings
Categorical
High correlation Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 418 |
| Missing (%) | 83.6% |
| Memory size | 31.1 KiB |
| 12.0 | |
|---|---|
| 14.0 | |
| 8.0 | |
| 15.0 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.7682927 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 14.0 |
|---|---|
| 2nd row | 8.0 |
| 3rd row | 14.0 |
| 4th row | 15.0 |
| 5th row | 12.0 |
Common Values
| Value | Count | Frequency (%) |
| 12.0 | 25 | 5.0% |
| 14.0 | 22 | 4.4% |
| 8.0 | 19 | 3.8% |
| 15.0 | 16 | 3.2% |
| (Missing) | 418 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 12.0 | 25 | |
| 14.0 | 22 | |
| 8.0 | 19 | |
| 15.0 | 16 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 82 | |
| 0 | 82 | |
| 1 | 63 | |
| 2 | 25 | 8.1% |
| 4 | 22 | 7.1% |
| 8 | 19 | 6.1% |
| 5 | 16 | 5.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 309 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 82 | |
| 0 | 82 | |
| 1 | 63 | |
| 2 | 25 | 8.1% |
| 4 | 22 | 7.1% |
| 8 | 19 | 6.1% |
| 5 | 16 | 5.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 309 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 82 | |
| 0 | 82 | |
| 1 | 63 | |
| 2 | 25 | 8.1% |
| 4 | 22 | 7.1% |
| 8 | 19 | 6.1% |
| 5 | 16 | 5.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 309 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 82 | |
| 0 | 82 | |
| 1 | 63 | |
| 2 | 25 | 8.1% |
| 4 | 22 | 7.1% |
| 8 | 19 | 6.1% |
| 5 | 16 | 5.2% |
technology
Categorical
High correlation Missing
| Distinct | 9 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 35.2 KiB |
| Compressor Cooling | |
|---|---|
| Electronic Control | |
| Evaporative Cooling | |
| Direct Cool | |
| Non-Inverter | |
| Other values (4) |
Length
| Max length | 19 |
|---|---|
| Median length | 18 |
| Mean length | 15.080412 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Electronic Control |
|---|---|
| 2nd row | Fully-Automatic |
| 3rd row | Inverter |
| 4th row | Non-Inverter |
| 5th row | Non-Inverter |
Common Values
| Value | Count | Frequency (%) |
| Compressor Cooling | 86 | |
| Electronic Control | 82 | |
| Evaporative Cooling | 77 | |
| Direct Cool | 50 | |
| Non-Inverter | 47 | |
| Frost Free | 40 | |
| Fully-Automatic | 39 | |
| Semi-Automatic | 36 | |
| Inverter | 28 | 5.6% |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| cooling | 163 | |
| compressor | 86 | |
| electronic | 82 | |
| control | 82 | |
| evaporative | 77 | |
| direct | 50 | 6.1% |
| cool | 50 | 6.1% |
| non-inverter | 47 | 5.7% |
| frost | 40 | 4.9% |
| free | 40 | 4.9% |
| Other values (3) | 103 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 1083 | |
| r | 693 | 9.5% |
| e | 561 | 7.7% |
| t | 556 | 7.6% |
| i | 483 | 6.6% |
| l | 455 | 6.2% |
| n | 449 | 6.1% |
| C | 381 | 5.2% |
| 335 | 4.6% | |
| c | 289 | 4.0% |
| Other values (16) | 2029 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7314 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 1083 | |
| r | 693 | 9.5% |
| e | 561 | 7.7% |
| t | 556 | 7.6% |
| i | 483 | 6.6% |
| l | 455 | 6.2% |
| n | 449 | 6.1% |
| C | 381 | 5.2% |
| 335 | 4.6% | |
| c | 289 | 4.0% |
| Other values (16) | 2029 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7314 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 1083 | |
| r | 693 | 9.5% |
| e | 561 | 7.7% |
| t | 556 | 7.6% |
| i | 483 | 6.6% |
| l | 455 | 6.2% |
| n | 449 | 6.1% |
| C | 381 | 5.2% |
| 335 | 4.6% | |
| c | 289 | 4.0% |
| Other values (16) | 2029 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7314 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 1083 | |
| r | 693 | 9.5% |
| e | 561 | 7.7% |
| t | 556 | 7.6% |
| i | 483 | 6.6% |
| l | 455 | 6.2% |
| n | 449 | 6.1% |
| C | 381 | 5.2% |
| 335 | 4.6% | |
| c | 289 | 4.0% |
| Other values (16) | 2029 |
feature_1
Categorical
High correlation Missing
| Distinct | 17 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 35.2 KiB |
| ProSmart Inverter Motor | |
|---|---|
| Hot & Cold | |
| StoreFresh+ | |
| Hygiene+ | |
| Hot, Normal & Cold | |
| Other values (12) |
Length
| Max length | 23 |
|---|---|
| Median length | 18 |
| Mean length | 15 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ProSmart Inverter Motor |
|---|---|
| 2nd row | ProSmart Inverter Motor |
| 3rd row | Turbo Mode |
| 4th row | Self Diagnosis |
| 5th row | Turbo Mode |
Common Values
| Value | Count | Frequency (%) |
| ProSmart Inverter Motor | 62 | 12.4% |
| Hot & Cold | 33 | 6.6% |
| StoreFresh+ | 33 | 6.6% |
| Hygiene+ | 30 | 6.0% |
| Hot, Normal & Cold | 30 | 6.0% |
| Turbo Mode | 29 | 5.8% |
| NeoFrost Dual Cooling | 29 | 5.8% |
| GentleWave Drum | 28 | 5.6% |
| Remote Control | 28 | 5.6% |
| Active Fresh Blue Light | 27 | 5.4% |
| Other values (7) | 156 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 87 | 7.7% | |
| cold | 87 | 7.7% |
| hot | 63 | 5.6% |
| motor | 62 | 5.5% |
| inverter | 62 | 5.5% |
| prosmart | 62 | 5.5% |
| normal | 54 | 4.8% |
| cooling | 52 | 4.6% |
| storefresh | 33 | 2.9% |
| hygiene | 30 | 2.6% |
| Other values (21) | 541 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 801 | 11.0% |
| e | 707 | 9.7% |
| 648 | 8.9% | |
| r | 595 | 8.2% |
| t | 508 | 7.0% |
| l | 352 | 4.8% |
| a | 319 | 4.4% |
| n | 293 | 4.0% |
| m | 235 | 3.2% |
| s | 221 | 3.0% |
| Other values (31) | 2596 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7275 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 801 | 11.0% |
| e | 707 | 9.7% |
| 648 | 8.9% | |
| r | 595 | 8.2% |
| t | 508 | 7.0% |
| l | 352 | 4.8% |
| a | 319 | 4.4% |
| n | 293 | 4.0% |
| m | 235 | 3.2% |
| s | 221 | 3.0% |
| Other values (31) | 2596 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7275 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 801 | 11.0% |
| e | 707 | 9.7% |
| 648 | 8.9% | |
| r | 595 | 8.2% |
| t | 508 | 7.0% |
| l | 352 | 4.8% |
| a | 319 | 4.4% |
| n | 293 | 4.0% |
| m | 235 | 3.2% |
| s | 221 | 3.0% |
| Other values (31) | 2596 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7275 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 801 | 11.0% |
| e | 707 | 9.7% |
| 648 | 8.9% | |
| r | 595 | 8.2% |
| t | 508 | 7.0% |
| l | 352 | 4.8% |
| a | 319 | 4.4% |
| n | 293 | 4.0% |
| m | 235 | 3.2% |
| s | 221 | 3.0% |
| Other values (31) | 2596 |
energy_rating_stars
Categorical
Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 90 |
| Missing (%) | 18.0% |
| Memory size | 29.8 KiB |
| 3.0 | |
|---|---|
| 5.0 | |
| 2.0 | |
| 4.0 | |
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3.0 |
|---|---|
| 2nd row | 3.0 |
| 3rd row | 1.0 |
| 4th row | 3.0 |
| 5th row | 3.0 |
Common Values
| Value | Count | Frequency (%) |
| 3.0 | 88 | |
| 5.0 | 87 | |
| 2.0 | 81 | |
| 4.0 | 79 | |
| 1.0 | 75 | |
| (Missing) | 90 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3.0 | 88 | |
| 5.0 | 87 | |
| 2.0 | 81 | |
| 4.0 | 79 | |
| 1.0 | 75 |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 410 | |
| 0 | 410 | |
| 3 | 88 | 7.2% |
| 5 | 87 | 7.1% |
| 2 | 81 | 6.6% |
| 4 | 79 | 6.4% |
| 1 | 75 | 6.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1230 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 410 | |
| 0 | 410 | |
| 3 | 88 | 7.2% |
| 5 | 87 | 7.1% |
| 2 | 81 | 6.6% |
| 4 | 79 | 6.4% |
| 1 | 75 | 6.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1230 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 410 | |
| 0 | 410 | |
| 3 | 88 | 7.2% |
| 5 | 87 | 7.1% |
| 2 | 81 | 6.6% |
| 4 | 79 | 6.4% |
| 1 | 75 | 6.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1230 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 410 | |
| 0 | 410 | |
| 3 | 88 | 7.2% |
| 5 | 87 | 7.1% |
| 2 | 81 | 6.6% |
| 4 | 79 | 6.4% |
| 1 | 75 | 6.1% |
color
Categorical
Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 30.3 KiB |
| Grey | |
|---|---|
| Silver | |
| White | |
| Blue | |
| Black |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 4.7979381 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Blue |
|---|---|
| 2nd row | Silver |
| 3rd row | Blue |
| 4th row | Grey |
| 5th row | Black |
Common Values
| Value | Count | Frequency (%) |
| Grey | 105 | |
| Silver | 102 | |
| White | 97 | |
| Blue | 95 | |
| Black | 86 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| grey | 105 | |
| silver | 102 | |
| white | 97 | |
| blue | 95 | |
| black | 86 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 399 | |
| l | 283 | |
| r | 207 | 8.9% |
| i | 199 | 8.6% |
| B | 181 | 7.8% |
| y | 105 | 4.5% |
| G | 105 | 4.5% |
| S | 102 | 4.4% |
| v | 102 | 4.4% |
| W | 97 | 4.2% |
| Other values (6) | 547 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2327 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 399 | |
| l | 283 | |
| r | 207 | 8.9% |
| i | 199 | 8.6% |
| B | 181 | 7.8% |
| y | 105 | 4.5% |
| G | 105 | 4.5% |
| S | 102 | 4.4% |
| v | 102 | 4.4% |
| W | 97 | 4.2% |
| Other values (6) | 547 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2327 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 399 | |
| l | 283 | |
| r | 207 | 8.9% |
| i | 199 | 8.6% |
| B | 181 | 7.8% |
| y | 105 | 4.5% |
| G | 105 | 4.5% |
| S | 102 | 4.4% |
| v | 102 | 4.4% |
| W | 97 | 4.2% |
| Other values (6) | 547 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2327 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 399 | |
| l | 283 | |
| r | 207 | 8.9% |
| i | 199 | 8.6% |
| B | 181 | 7.8% |
| y | 105 | 4.5% |
| G | 105 | 4.5% |
| S | 102 | 4.4% |
| v | 102 | 4.4% |
| W | 97 | 4.2% |
| Other values (6) | 547 |
price_inr
Real number (ℝ)
Missing
| Distinct | 484 |
|---|---|
| Distinct (%) | 99.8% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46567.21 |
| Minimum | 8351 |
|---|---|
| Maximum | 84989 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 8351 |
|---|---|
| 5-th percentile | 10859.8 |
| Q1 | 25661 |
| median | 46386 |
| Q3 | 67550 |
| 95-th percentile | 81846.8 |
| Maximum | 84989 |
| Range | 76638 |
| Interquartile range (IQR) | 41889 |
Descriptive statistics
| Standard deviation | 23234.383 |
|---|---|
| Coefficient of variation (CV) | 0.49894299 |
| Kurtosis | -1.3193355 |
| Mean | 46567.21 |
| Median Absolute Deviation (MAD) | 21151 |
| Skewness | -0.0056022845 |
| Sum | 22585097 |
| Variance | 5.3983655 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 16595 | 2 | 0.4% |
| 84989 | 1 | 0.2% |
| 70115 | 1 | 0.2% |
| 61826 | 1 | 0.2% |
| 18381 | 1 | 0.2% |
| 65780 | 1 | 0.2% |
| 58709 | 1 | 0.2% |
| 20069 | 1 | 0.2% |
| 34240 | 1 | 0.2% |
| 60659 | 1 | 0.2% |
| Other values (474) | 474 | |
| (Missing) | 15 | 3.0% |
| Value | Count | Frequency (%) |
| 8351 | 1 | |
| 8437 | 1 | |
| 8906 | 1 | |
| 9064 | 1 | |
| 9148 | 1 | |
| 9247 | 1 | |
| 9258 | 1 | |
| 9309 | 1 | |
| 9373 | 1 | |
| 9694 | 1 |
| Value | Count | Frequency (%) |
| 84989 | 1 | |
| 84931 | 1 | |
| 84786 | 1 | |
| 84533 | 1 | |
| 84352 | 1 | |
| 84281 | 1 | |
| 84196 | 1 | |
| 83970 | 1 | |
| 83862 | 1 | |
| 83766 | 1 |
Missing
| Distinct | 377 |
|---|---|
| Distinct (%) | 77.7% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 4.0 KiB |
| Minimum | 2022-01-02 00:00:00 |
|---|---|
| Maximum | 2024-12-01 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
warranty_years
Categorical
High correlation Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 29.6 KiB |
| 2.0 | |
|---|---|
| 10.0 | |
| 1.0 | |
| 5.0 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.2515464 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 10.0 |
|---|---|
| 2nd row | 10.0 |
| 3rd row | 1.0 |
| 4th row | 2.0 |
| 5th row | 10.0 |
Common Values
| Value | Count | Frequency (%) |
| 2.0 | 137 | |
| 10.0 | 122 | |
| 1.0 | 114 | |
| 5.0 | 112 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2.0 | 137 | |
| 10.0 | 122 | |
| 1.0 | 114 | |
| 5.0 | 112 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 607 | |
| . | 485 | |
| 1 | 236 | 15.0% |
| 2 | 137 | 8.7% |
| 5 | 112 | 7.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1577 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 607 | |
| . | 485 | |
| 1 | 236 | 15.0% |
| 2 | 137 | 8.7% |
| 5 | 112 | 7.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1577 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 607 | |
| . | 485 | |
| 1 | 236 | 15.0% |
| 2 | 137 | 8.7% |
| 5 | 112 | 7.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1577 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 607 | |
| . | 485 | |
| 1 | 236 | 15.0% |
| 2 | 137 | 8.7% |
| 5 | 112 | 7.1% |
customer_rating
Real number (ℝ)
Missing
| Distinct | 21 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9971134 |
| Minimum | 3 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3.1 |
| Q1 | 3.5 |
| median | 4 |
| Q3 | 4.5 |
| 95-th percentile | 4.9 |
| Maximum | 5 |
| Range | 2 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.59072717 |
|---|---|
| Coefficient of variation (CV) | 0.14778844 |
| Kurtosis | -1.1993161 |
| Mean | 3.9971134 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.010956278 |
| Sum | 1938.6 |
| Variance | 0.34895859 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 4.6 | 33 | 6.6% |
| 3.1 | 32 | 6.4% |
| 3.8 | 29 | 5.8% |
| 4 | 29 | 5.8% |
| 4.9 | 26 | 5.2% |
| 4.8 | 26 | 5.2% |
| 3.4 | 26 | 5.2% |
| 4.4 | 25 | 5.0% |
| 4.2 | 24 | 4.8% |
| 3.3 | 24 | 4.8% |
| Other values (11) | 211 |
| Value | Count | Frequency (%) |
| 3 | 11 | 2.2% |
| 3.1 | 32 | |
| 3.2 | 24 | |
| 3.3 | 24 | |
| 3.4 | 26 | |
| 3.5 | 21 | |
| 3.6 | 17 | |
| 3.7 | 23 | |
| 3.8 | 29 | |
| 3.9 | 23 |
| Value | Count | Frequency (%) |
| 5 | 15 | |
| 4.9 | 26 | |
| 4.8 | 26 | |
| 4.7 | 17 | |
| 4.6 | 33 | |
| 4.5 | 17 | |
| 4.4 | 25 | |
| 4.3 | 19 | |
| 4.2 | 24 | |
| 4.1 | 24 |
city
Categorical
Missing
| Distinct | 7 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 31.2 KiB |
| Pune | |
|---|---|
| Hyderabad | |
| Mumbai | |
| Kolkata | |
| Chennai | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.5938144 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Delhi |
|---|---|
| 2nd row | Delhi |
| 3rd row | Bangalore |
| 4th row | Hyderabad |
| 5th row | Bangalore |
Common Values
| Value | Count | Frequency (%) |
| Pune | 83 | |
| Hyderabad | 71 | |
| Mumbai | 70 | |
| Kolkata | 69 | |
| Chennai | 68 | |
| Delhi | 67 | |
| Bangalore | 57 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| pune | 83 | |
| hyderabad | 71 | |
| mumbai | 70 | |
| kolkata | 69 | |
| chennai | 68 | |
| delhi | 67 | |
| bangalore | 57 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 532 | |
| e | 346 | 10.8% |
| n | 276 | 8.6% |
| i | 205 | 6.4% |
| l | 193 | 6.0% |
| u | 153 | 4.8% |
| d | 142 | 4.4% |
| b | 141 | 4.4% |
| h | 135 | 4.2% |
| r | 128 | 4.0% |
| Other values (13) | 947 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3198 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 532 | |
| e | 346 | 10.8% |
| n | 276 | 8.6% |
| i | 205 | 6.4% |
| l | 193 | 6.0% |
| u | 153 | 4.8% |
| d | 142 | 4.4% |
| b | 141 | 4.4% |
| h | 135 | 4.2% |
| r | 128 | 4.0% |
| Other values (13) | 947 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3198 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 532 | |
| e | 346 | 10.8% |
| n | 276 | 8.6% |
| i | 205 | 6.4% |
| l | 193 | 6.0% |
| u | 153 | 4.8% |
| d | 142 | 4.4% |
| b | 141 | 4.4% |
| h | 135 | 4.2% |
| r | 128 | 4.0% |
| Other values (13) | 947 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3198 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 532 | |
| e | 346 | 10.8% |
| n | 276 | 8.6% |
| i | 205 | 6.4% |
| l | 193 | 6.0% |
| u | 153 | 4.8% |
| d | 142 | 4.4% |
| b | 141 | 4.4% |
| h | 135 | 4.2% |
| r | 128 | 4.0% |
| Other values (13) | 947 |
platform
Categorical
Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 31.6 KiB |
| Amazon | |
|---|---|
| Croma | |
| Vijay Sales | |
| Flipkart |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 7.4762887 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Amazon |
|---|---|
| 2nd row | Amazon |
| 3rd row | Flipkart |
| 4th row | Vijay Sales |
| 5th row | Amazon |
Common Values
| Value | Count | Frequency (%) |
| Amazon | 124 | |
| Croma | 122 | |
| Vijay Sales | 120 | |
| Flipkart | 119 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| amazon | 124 | |
| croma | 122 | |
| vijay | 120 | |
| sales | 120 | |
| flipkart | 119 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 605 | |
| o | 246 | 6.8% |
| m | 246 | 6.8% |
| r | 241 | 6.6% |
| i | 239 | 6.6% |
| l | 239 | 6.6% |
| A | 124 | 3.4% |
| z | 124 | 3.4% |
| n | 124 | 3.4% |
| C | 122 | 3.4% |
| Other values (11) | 1316 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3626 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 605 | |
| o | 246 | 6.8% |
| m | 246 | 6.8% |
| r | 241 | 6.6% |
| i | 239 | 6.6% |
| l | 239 | 6.6% |
| A | 124 | 3.4% |
| z | 124 | 3.4% |
| n | 124 | 3.4% |
| C | 122 | 3.4% |
| Other values (11) | 1316 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3626 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 605 | |
| o | 246 | 6.8% |
| m | 246 | 6.8% |
| r | 241 | 6.6% |
| i | 239 | 6.6% |
| l | 239 | 6.6% |
| A | 124 | 3.4% |
| z | 124 | 3.4% |
| n | 124 | 3.4% |
| C | 122 | 3.4% |
| Other values (11) | 1316 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3626 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 605 | |
| o | 246 | 6.8% |
| m | 246 | 6.8% |
| r | 241 | 6.6% |
| i | 239 | 6.6% |
| l | 239 | 6.6% |
| A | 124 | 3.4% |
| z | 124 | 3.4% |
| n | 124 | 3.4% |
| C | 122 | 3.4% |
| Other values (11) | 1316 |
discount_offered
Real number (ℝ)
Missing Zeros
| Distinct | 7 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.164948 |
| Minimum | 0 |
|---|---|
| Maximum | 30 |
| Zeros | 63 |
| Zeros (%) | 12.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5 |
| median | 15 |
| Q3 | 25 |
| 95-th percentile | 30 |
| Maximum | 30 |
| Range | 30 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 9.957223 |
|---|---|
| Coefficient of variation (CV) | 0.65659458 |
| Kurtosis | -1.2484198 |
| Mean | 15.164948 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | -0.0047246989 |
| Sum | 7355 |
| Variance | 99.14629 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 5 | 76 | |
| 15 | 75 | |
| 30 | 71 | |
| 25 | 70 | |
| 20 | 67 | |
| 10 | 63 | |
| 0 | 63 | |
| (Missing) | 15 | 3.0% |
| Value | Count | Frequency (%) |
| 0 | 63 | |
| 5 | 76 | |
| 10 | 63 | |
| 15 | 75 | |
| 20 | 67 | |
| 25 | 70 | |
| 30 | 71 |
| Value | Count | Frequency (%) |
| 30 | 71 | |
| 25 | 70 | |
| 20 | 67 | |
| 15 | 75 | |
| 10 | 63 | |
| 5 | 76 | |
| 0 | 63 |
availability
Categorical
Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 32.8 KiB |
| Out of Stock | |
|---|---|
| In Stock |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 10.061856 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Out of Stock |
|---|---|
| 2nd row | Out of Stock |
| 3rd row | In Stock |
| 4th row | Out of Stock |
| 5th row | In Stock |
Common Values
| Value | Count | Frequency (%) |
| Out of Stock | 250 | |
| In Stock | 235 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| stock | 485 | |
| out | 250 | |
| of | 250 | |
| in | 235 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 735 | |
| o | 735 | |
| 735 | ||
| k | 485 | |
| c | 485 | |
| S | 485 | |
| O | 250 | 5.1% |
| u | 250 | 5.1% |
| f | 250 | 5.1% |
| I | 235 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4880 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 735 | |
| o | 735 | |
| 735 | ||
| k | 485 | |
| c | 485 | |
| S | 485 | |
| O | 250 | 5.1% |
| u | 250 | 5.1% |
| f | 250 | 5.1% |
| I | 235 | 4.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4880 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 735 | |
| o | 735 | |
| 735 | ||
| k | 485 | |
| c | 485 | |
| S | 485 | |
| O | 250 | 5.1% |
| u | 250 | 5.1% |
| f | 250 | 5.1% |
| I | 235 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4880 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 735 | |
| o | 735 | |
| 735 | ||
| k | 485 | |
| c | 485 | |
| S | 485 | |
| O | 250 | 5.1% |
| u | 250 | 5.1% |
| f | 250 | 5.1% |
| I | 235 | 4.8% |
warranty_duration_months
Categorical
High correlation Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 30.1 KiB |
| 24.0 | |
|---|---|
| 120.0 | |
| 12.0 | |
| 60.0 |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 4.257732 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 120.0 |
|---|---|
| 2nd row | 120.0 |
| 3rd row | 12.0 |
| 4th row | 24.0 |
| 5th row | 120.0 |
Common Values
| Value | Count | Frequency (%) |
| 24.0 | 134 | |
| 120.0 | 125 | |
| 12.0 | 113 | |
| 60.0 | 113 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 24.0 | 134 | |
| 120.0 | 125 | |
| 12.0 | 113 | |
| 60.0 | 113 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 723 | |
| . | 485 | |
| 2 | 372 | |
| 1 | 238 | 11.5% |
| 4 | 134 | 6.5% |
| 6 | 113 | 5.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2065 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 723 | |
| . | 485 | |
| 2 | 372 | |
| 1 | 238 | 11.5% |
| 4 | 134 | 6.5% |
| 6 | 113 | 5.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2065 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 723 | |
| . | 485 | |
| 2 | 372 | |
| 1 | 238 | 11.5% |
| 4 | 134 | 6.5% |
| 6 | 113 | 5.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2065 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 723 | |
| . | 485 | |
| 2 | 372 | |
| 1 | 238 | 11.5% |
| 4 | 134 | 6.5% |
| 6 | 113 | 5.5% |
review_sentiment
Categorical
Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 31.7 KiB |
| Neutral | |
|---|---|
| Negative | |
| Positive |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.6536082 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Positive |
|---|---|
| 2nd row | Positive |
| 3rd row | Positive |
| 4th row | Neutral |
| 5th row | Positive |
Common Values
| Value | Count | Frequency (%) |
| Neutral | 168 | |
| Negative | 163 | |
| Positive | 154 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| neutral | 168 | |
| negative | 163 | |
| positive | 154 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 648 | |
| t | 485 | |
| i | 471 | |
| a | 331 | |
| N | 331 | |
| v | 317 | |
| u | 168 | 4.5% |
| r | 168 | 4.5% |
| l | 168 | 4.5% |
| g | 163 | 4.4% |
| Other values (3) | 462 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3712 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 648 | |
| t | 485 | |
| i | 471 | |
| a | 331 | |
| N | 331 | |
| v | 317 | |
| u | 168 | 4.5% |
| r | 168 | 4.5% |
| l | 168 | 4.5% |
| g | 163 | 4.4% |
| Other values (3) | 462 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3712 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 648 | |
| t | 485 | |
| i | 471 | |
| a | 331 | |
| N | 331 | |
| v | 317 | |
| u | 168 | 4.5% |
| r | 168 | 4.5% |
| l | 168 | 4.5% |
| g | 163 | 4.4% |
| Other values (3) | 462 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3712 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 648 | |
| t | 485 | |
| i | 471 | |
| a | 331 | |
| N | 331 | |
| v | 317 | |
| u | 168 | 4.5% |
| r | 168 | 4.5% |
| l | 168 | 4.5% |
| g | 163 | 4.4% |
| Other values (3) | 462 |
return_status
Categorical
Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 32.8 KiB |
| Not Returned | |
|---|---|
| Returned |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 10.086598 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Not Returned |
|---|---|
| 2nd row | Returned |
| 3rd row | Not Returned |
| 4th row | Not Returned |
| 5th row | Returned |
Common Values
| Value | Count | Frequency (%) |
| Not Returned | 253 | |
| Returned | 232 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| returned | 485 | |
| not | 253 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 970 | |
| t | 738 | |
| n | 485 | |
| r | 485 | |
| R | 485 | |
| u | 485 | |
| d | 485 | |
| N | 253 | 5.2% |
| o | 253 | 5.2% |
| 253 | 5.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4892 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 970 | |
| t | 738 | |
| n | 485 | |
| r | 485 | |
| R | 485 | |
| u | 485 | |
| d | 485 | |
| N | 253 | 5.2% |
| o | 253 | 5.2% |
| 253 | 5.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4892 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 970 | |
| t | 738 | |
| n | 485 | |
| r | 485 | |
| R | 485 | |
| u | 485 | |
| d | 485 | |
| N | 253 | 5.2% |
| o | 253 | 5.2% |
| 253 | 5.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4892 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 970 | |
| t | 738 | |
| n | 485 | |
| r | 485 | |
| R | 485 | |
| u | 485 | |
| d | 485 | |
| N | 253 | 5.2% |
| o | 253 | 5.2% |
| 253 | 5.2% |
complaint_text
Categorical
Missing
| Distinct | 7 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 39.8 KiB |
| Excellent performance. | |
|---|---|
| Slow installation service. | |
| Delivered with damaged packaging. | |
| No issues so far. | |
| Remote stopped working. | |
| Other values (2) |
Length
| Max length | 33 |
|---|---|
| Median length | 25 |
| Mean length | 24.884536 |
| Min length | 17 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Delivered with damaged packaging. |
|---|---|
| 2nd row | Cooling issue after 2 months. |
| 3rd row | Delivered with damaged packaging. |
| 4th row | Noisy operation at night. |
| 5th row | Excellent performance. |
Common Values
| Value | Count | Frequency (%) |
| Excellent performance. | 87 | |
| Slow installation service. | 73 | |
| Delivered with damaged packaging. | 72 | |
| No issues so far. | 68 | |
| Remote stopped working. | 66 | |
| Noisy operation at night. | 61 | |
| Cooling issue after 2 months. | 58 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| excellent | 87 | 5.2% |
| performance | 87 | 5.2% |
| slow | 73 | 4.3% |
| installation | 73 | 4.3% |
| service | 73 | 4.3% |
| delivered | 72 | 4.3% |
| with | 72 | 4.3% |
| damaged | 72 | 4.3% |
| packaging | 72 | 4.3% |
| no | 68 | 4.0% |
| Other values (15) | 936 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1225 | 10.1% |
| 1200 | 9.9% | |
| o | 924 | 7.7% |
| i | 868 | 7.2% |
| a | 769 | 6.4% |
| t | 736 | 6.1% |
| s | 719 | 6.0% |
| n | 696 | 5.8% |
| r | 572 | 4.7% |
| l | 523 | 4.3% |
| Other values (21) | 3837 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12069 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1225 | 10.1% |
| 1200 | 9.9% | |
| o | 924 | 7.7% |
| i | 868 | 7.2% |
| a | 769 | 6.4% |
| t | 736 | 6.1% |
| s | 719 | 6.0% |
| n | 696 | 5.8% |
| r | 572 | 4.7% |
| l | 523 | 4.3% |
| Other values (21) | 3837 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12069 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1225 | 10.1% |
| 1200 | 9.9% | |
| o | 924 | 7.7% |
| i | 868 | 7.2% |
| a | 769 | 6.4% |
| t | 736 | 6.1% |
| s | 719 | 6.0% |
| n | 696 | 5.8% |
| r | 572 | 4.7% |
| l | 523 | 4.3% |
| Other values (21) | 3837 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12069 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1225 | 10.1% |
| 1200 | 9.9% | |
| o | 924 | 7.7% |
| i | 868 | 7.2% |
| a | 769 | 6.4% |
| t | 736 | 6.1% |
| s | 719 | 6.0% |
| n | 696 | 5.8% |
| r | 572 | 4.7% |
| l | 523 | 4.3% |
| Other values (21) | 3837 |
resolved_status
Categorical
Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 32.7 KiB |
| In Progress | |
|---|---|
| Unresolved | |
| Resolved |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 9.7051546 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Resolved |
|---|---|
| 2nd row | In Progress |
| 3rd row | Unresolved |
| 4th row | Resolved |
| 5th row | Resolved |
Common Values
| Value | Count | Frequency (%) |
| In Progress | 169 | |
| Unresolved | 160 | |
| Resolved | 156 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| in | 169 | |
| progress | 169 | |
| unresolved | 160 | |
| resolved | 156 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 801 | |
| s | 654 | |
| r | 498 | |
| o | 485 | |
| n | 329 | |
| v | 316 | 6.7% |
| d | 316 | 6.7% |
| l | 316 | 6.7% |
| I | 169 | 3.6% |
| P | 169 | 3.6% |
| Other values (4) | 654 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4707 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 801 | |
| s | 654 | |
| r | 498 | |
| o | 485 | |
| n | 329 | |
| v | 316 | 6.7% |
| d | 316 | 6.7% |
| l | 316 | 6.7% |
| I | 169 | 3.6% |
| P | 169 | 3.6% |
| Other values (4) | 654 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4707 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 801 | |
| s | 654 | |
| r | 498 | |
| o | 485 | |
| n | 329 | |
| v | 316 | 6.7% |
| d | 316 | 6.7% |
| l | 316 | 6.7% |
| I | 169 | 3.6% |
| P | 169 | 3.6% |
| Other values (4) | 654 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4707 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 801 | |
| s | 654 | |
| r | 498 | |
| o | 485 | |
| n | 329 | |
| v | 316 | 6.7% |
| d | 316 | 6.7% |
| l | 316 | 6.7% |
| I | 169 | 3.6% |
| P | 169 | 3.6% |
| Other values (4) | 654 |
review_date
Date
Missing
| Distinct | 371 |
|---|---|
| Distinct (%) | 76.5% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 4.0 KiB |
| Minimum | 2022-01-01 00:00:00 |
|---|---|
| Maximum | 2024-12-03 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
reviewer_location
Categorical
Missing
| Distinct | 7 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 31.4 KiB |
| Hyderabad | |
|---|---|
| Ahmedabad | |
| Chennai | |
| Mumbai | |
| Pune | |
| Other values (2) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.1319588 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Delhi |
|---|---|
| 2nd row | Chennai |
| 3rd row | Bangalore |
| 4th row | Pune |
| 5th row | Pune |
Common Values
| Value | Count | Frequency (%) |
| Hyderabad | 87 | |
| Ahmedabad | 79 | |
| Chennai | 74 | |
| Mumbai | 65 | |
| Pune | 63 | |
| Delhi | 62 | |
| Bangalore | 55 | |
| (Missing) | 15 | 3.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| hyderabad | 87 | |
| ahmedabad | 79 | |
| chennai | 74 | |
| mumbai | 65 | |
| pune | 63 | |
| delhi | 62 | |
| bangalore | 55 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 581 | |
| e | 420 | |
| d | 332 | |
| n | 266 | 7.7% |
| b | 231 | 6.7% |
| h | 215 | 6.2% |
| i | 201 | 5.8% |
| m | 144 | 4.2% |
| r | 142 | 4.1% |
| u | 128 | 3.7% |
| Other values (11) | 799 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3459 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 581 | |
| e | 420 | |
| d | 332 | |
| n | 266 | 7.7% |
| b | 231 | 6.7% |
| h | 215 | 6.2% |
| i | 201 | 5.8% |
| m | 144 | 4.2% |
| r | 142 | 4.1% |
| u | 128 | 3.7% |
| Other values (11) | 799 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3459 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 581 | |
| e | 420 | |
| d | 332 | |
| n | 266 | 7.7% |
| b | 231 | 6.7% |
| h | 215 | 6.2% |
| i | 201 | 5.8% |
| m | 144 | 4.2% |
| r | 142 | 4.1% |
| u | 128 | 3.7% |
| Other values (11) | 799 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3459 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 581 | |
| e | 420 | |
| d | 332 | |
| n | 266 | 7.7% |
| b | 231 | 6.7% |
| h | 215 | 6.2% |
| i | 201 | 5.8% |
| m | 144 | 4.2% |
| r | 142 | 4.1% |
| u | 128 | 3.7% |
| Other values (11) | 799 |
product_name
Text
Missing
| Distinct | 485 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 15 |
| Missing (%) | 3.0% |
| Memory size | 48.1 KiB |
Length
| Max length | 50 |
|---|---|
| Median length | 47 |
| Mean length | 43.253608 |
| Min length | 34 |
Unique
| Unique | 485 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Voltas Table Top Dishwasher (Model_N299) |
|---|---|
| 2nd row | Voltas Top Load Washing Machine (Model_K244) |
| 3rd row | Voltas Inverter AC Air Conditioner (Model_X75) |
| 4th row | Voltas Window AC Air Conditioner (Model_X101) |
| 5th row | Voltas Split AC Air Conditioner (Model_Y128) |
| Value | Count | Frequency (%) |
| voltas | 476 | 18.1% |
| air | 148 | 5.6% |
| top | 122 | 4.6% |
| refrigerator | 85 | 3.2% |
| water | 83 | 3.2% |
| dispenser | 81 | 3.1% |
| loading | 81 | 3.1% |
| cooler | 78 | 3.0% |
| dishwasher | 77 | 2.9% |
| machine | 75 | 2.9% |
| Other values (553) | 1323 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2144 | 10.2% | |
| o | 1990 | 9.5% |
| e | 1592 | 7.6% |
| l | 1287 | 6.1% |
| a | 1127 | 5.4% |
| r | 1048 | 5.0% |
| i | 971 | 4.6% |
| s | 955 | 4.6% |
| t | 930 | 4.4% |
| d | 803 | 3.8% |
| Other values (53) | 8131 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20978 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2144 | 10.2% | |
| o | 1990 | 9.5% |
| e | 1592 | 7.6% |
| l | 1287 | 6.1% |
| a | 1127 | 5.4% |
| r | 1048 | 5.0% |
| i | 971 | 4.6% |
| s | 955 | 4.6% |
| t | 930 | 4.4% |
| d | 803 | 3.8% |
| Other values (53) | 8131 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20978 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2144 | 10.2% | |
| o | 1990 | 9.5% |
| e | 1592 | 7.6% |
| l | 1287 | 6.1% |
| a | 1127 | 5.4% |
| r | 1048 | 5.0% |
| i | 971 | 4.6% |
| s | 955 | 4.6% |
| t | 930 | 4.4% |
| d | 803 | 3.8% |
| Other values (53) | 8131 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20978 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2144 | 10.2% | |
| o | 1990 | 9.5% |
| e | 1592 | 7.6% |
| l | 1287 | 6.1% |
| a | 1127 | 5.4% |
| r | 1048 | 5.0% |
| i | 971 | 4.6% |
| s | 955 | 4.6% |
| t | 930 | 4.4% |
| d | 803 | 3.8% |
| Other values (53) | 8131 |
username
Text
| Distinct | 497 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 33.2 KiB |
Length
| Max length | 17 |
|---|---|
| Median length | 13.5 |
| Mean length | 10.726 |
| Min length | 5 |
Unique
| Unique | 494 ? |
|---|---|
| Unique (%) | 98.8% |
Sample
| 1st row | arjun_20 |
|---|---|
| 2nd row | sanjay219 |
| 3rd row | nisha_buyer0 |
| 4th row | preeti_deals8 |
| 5th row | swati.buyer01 |
| Value | Count | Frequency (%) |
| ajay.3 | 2 | 0.4% |
| rohit_9 | 2 | 0.4% |
| amit.6 | 2 | 0.4% |
| sanjay219 | 1 | 0.2% |
| ajaydeals2 | 1 | 0.2% |
| sanjay.zone8 | 1 | 0.2% |
| komal.450 | 1 | 0.2% |
| preeti.buyer7 | 1 | 0.2% |
| vinod.4 | 1 | 0.2% |
| divya_user920 | 1 | 0.2% |
| Other values (487) | 487 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 581 | 10.8% |
| e | 497 | 9.3% |
| i | 388 | 7.2% |
| s | 342 | 6.4% |
| r | 325 | 6.1% |
| n | 285 | 5.3% |
| h | 197 | 3.7% |
| . | 171 | 3.2% |
| o | 169 | 3.2% |
| _ | 153 | 2.9% |
| Other values (24) | 2255 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5363 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 581 | 10.8% |
| e | 497 | 9.3% |
| i | 388 | 7.2% |
| s | 342 | 6.4% |
| r | 325 | 6.1% |
| n | 285 | 5.3% |
| h | 197 | 3.7% |
| . | 171 | 3.2% |
| o | 169 | 3.2% |
| _ | 153 | 2.9% |
| Other values (24) | 2255 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5363 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 581 | 10.8% |
| e | 497 | 9.3% |
| i | 388 | 7.2% |
| s | 342 | 6.4% |
| r | 325 | 6.1% |
| n | 285 | 5.3% |
| h | 197 | 3.7% |
| . | 171 | 3.2% |
| o | 169 | 3.2% |
| _ | 153 | 2.9% |
| Other values (24) | 2255 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5363 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 581 | 10.8% |
| e | 497 | 9.3% |
| i | 388 | 7.2% |
| s | 342 | 6.4% |
| r | 325 | 6.1% |
| n | 285 | 5.3% |
| h | 197 | 3.7% |
| . | 171 | 3.2% |
| o | 169 | 3.2% |
| _ | 153 | 2.9% |
| Other values (24) | 2255 |
Interactions
Correlations
| availability | capacity_kg | capacity_liters | capacity_place_settings | capacity_tons | city | color | complaint_text | customer_rating | discount_offered | energy_rating_stars | feature_1 | platform | price_inr | product_category | resolved_status | return_status | review_sentiment | reviewer_location | sub_type | technology | warranty_duration_months | warranty_years | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| availability | 1.000 | 0.118 | 0.000 | 0.000 | 0.000 | 0.095 | 0.000 | 0.000 | 0.000 | 0.000 | 0.039 | 0.095 | 0.054 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.034 | 0.000 | 0.000 | 0.000 | 0.000 |
| capacity_kg | 0.118 | 1.000 | 0.000 | 0.000 | 0.000 | 0.142 | 0.121 | 0.135 | 0.014 | 0.135 | 0.000 | 0.000 | 0.149 | 0.052 | 1.000 | 0.000 | 0.146 | 0.090 | 0.197 | 0.181 | 0.174 | 0.256 | 0.267 |
| capacity_liters | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.064 | 0.000 | 0.000 | -0.069 | -0.056 | 0.000 | 0.441 | 0.000 | 0.005 | 0.782 | 0.123 | 0.054 | 0.082 | 0.085 | 0.452 | 0.640 | 0.112 | 0.113 |
| capacity_place_settings | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.086 | 0.000 | 0.148 | 0.196 | 0.000 | 1.000 | 0.000 | 0.000 | 0.056 | 0.000 | 0.104 | 1.000 | 0.000 | 0.000 |
| capacity_tons | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.124 | 0.155 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.033 | 0.000 | 0.000 | 0.000 | 0.036 | 0.000 | 0.000 | 0.000 |
| city | 0.095 | 0.142 | 0.064 | 0.000 | 0.124 | 1.000 | 0.084 | 0.014 | 0.055 | 0.047 | 0.088 | 0.000 | 0.000 | 0.054 | 0.000 | 0.075 | 0.068 | 0.034 | 0.041 | 0.000 | 0.040 | 0.000 | 0.000 |
| color | 0.000 | 0.121 | 0.000 | 0.000 | 0.155 | 0.084 | 1.000 | 0.054 | 0.000 | 0.089 | 0.000 | 0.000 | 0.018 | 0.000 | 0.000 | 0.062 | 0.000 | 0.000 | 0.045 | 0.034 | 0.000 | 0.000 | 0.022 |
| complaint_text | 0.000 | 0.135 | 0.000 | 0.000 | 0.000 | 0.014 | 0.054 | 1.000 | 0.000 | 0.035 | 0.000 | 0.035 | 0.073 | 0.054 | 0.000 | 0.068 | 0.000 | 0.000 | 0.044 | 0.000 | 0.000 | 0.000 | 0.000 |
| customer_rating | 0.000 | 0.014 | -0.069 | 0.000 | 0.000 | 0.055 | 0.000 | 0.000 | 1.000 | 0.025 | 0.081 | 0.000 | 0.083 | -0.005 | 0.011 | 0.000 | 0.000 | 0.000 | 0.051 | 0.000 | 0.000 | 0.000 | 0.000 |
| discount_offered | 0.000 | 0.135 | -0.056 | 0.086 | 0.000 | 0.047 | 0.089 | 0.035 | 0.025 | 1.000 | 0.078 | 0.000 | 0.079 | 0.015 | 0.000 | 0.031 | 0.101 | 0.012 | 0.070 | 0.000 | 0.000 | 0.000 | 0.000 |
| energy_rating_stars | 0.039 | 0.000 | 0.000 | 0.000 | 0.000 | 0.088 | 0.000 | 0.000 | 0.081 | 0.078 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.062 | 0.067 | 0.000 | 0.000 | 0.024 | 0.085 | 0.000 | 0.000 |
| feature_1 | 0.095 | 0.000 | 0.441 | 0.148 | 0.000 | 0.000 | 0.000 | 0.035 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.102 | 0.947 | 0.113 | 0.000 | 0.000 | 0.071 | 0.567 | 0.745 | 0.000 | 0.000 |
| platform | 0.054 | 0.149 | 0.000 | 0.196 | 0.000 | 0.000 | 0.018 | 0.073 | 0.083 | 0.079 | 0.000 | 0.000 | 1.000 | 0.046 | 0.000 | 0.106 | 0.000 | 0.000 | 0.000 | 0.000 | 0.075 | 0.000 | 0.016 |
| price_inr | 0.000 | 0.052 | 0.005 | 0.000 | 0.000 | 0.054 | 0.000 | 0.054 | -0.005 | 0.015 | 0.000 | 0.102 | 0.046 | 1.000 | 0.047 | 0.084 | 0.047 | 0.000 | 0.000 | 0.061 | 0.057 | 0.000 | 0.000 |
| product_category | 0.000 | 1.000 | 0.782 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.011 | 0.000 | 0.000 | 0.947 | 0.000 | 0.047 | 1.000 | 0.137 | 0.000 | 0.052 | 0.000 | 0.990 | 0.997 | 0.055 | 0.064 |
| resolved_status | 0.000 | 0.000 | 0.123 | 0.000 | 0.033 | 0.075 | 0.062 | 0.068 | 0.000 | 0.031 | 0.062 | 0.113 | 0.106 | 0.084 | 0.137 | 1.000 | 0.000 | 0.000 | 0.000 | 0.113 | 0.122 | 0.075 | 0.072 |
| return_status | 0.000 | 0.146 | 0.054 | 0.000 | 0.000 | 0.068 | 0.000 | 0.000 | 0.000 | 0.101 | 0.067 | 0.000 | 0.000 | 0.047 | 0.000 | 0.000 | 1.000 | 0.000 | 0.043 | 0.028 | 0.000 | 0.000 | 0.000 |
| review_sentiment | 0.000 | 0.090 | 0.082 | 0.056 | 0.000 | 0.034 | 0.000 | 0.000 | 0.000 | 0.012 | 0.000 | 0.000 | 0.000 | 0.000 | 0.052 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.070 | 0.081 | 0.090 |
| reviewer_location | 0.034 | 0.197 | 0.085 | 0.000 | 0.000 | 0.041 | 0.045 | 0.044 | 0.051 | 0.070 | 0.000 | 0.071 | 0.000 | 0.000 | 0.000 | 0.000 | 0.043 | 0.000 | 1.000 | 0.116 | 0.000 | 0.000 | 0.000 |
| sub_type | 0.000 | 0.181 | 0.452 | 0.104 | 0.036 | 0.000 | 0.034 | 0.000 | 0.000 | 0.000 | 0.024 | 0.567 | 0.000 | 0.061 | 0.990 | 0.113 | 0.028 | 0.000 | 0.116 | 1.000 | 0.858 | 0.011 | 0.023 |
| technology | 0.000 | 0.174 | 0.640 | 1.000 | 0.000 | 0.040 | 0.000 | 0.000 | 0.000 | 0.000 | 0.085 | 0.745 | 0.075 | 0.057 | 0.997 | 0.122 | 0.000 | 0.070 | 0.000 | 0.858 | 1.000 | 0.049 | 0.058 |
| warranty_duration_months | 0.000 | 0.256 | 0.112 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.055 | 0.075 | 0.000 | 0.081 | 0.000 | 0.011 | 0.049 | 1.000 | 1.000 |
| warranty_years | 0.000 | 0.267 | 0.113 | 0.000 | 0.000 | 0.000 | 0.022 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.016 | 0.000 | 0.064 | 0.072 | 0.000 | 0.090 | 0.000 | 0.023 | 0.058 | 1.000 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| product_id | product_category | sub_type | model_name | capacity_tons | capacity_liters | capacity_kg | capacity_place_settings | technology | feature_1 | energy_rating_stars | color | price_inr | manufacturing_date | warranty_years | customer_rating | city | platform | discount_offered | availability | warranty_duration_months | review_sentiment | return_status | complaint_text | resolved_status | review_date | reviewer_location | product_name | username | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | PID433097 | Dishwasher | Table Top | Model_N299 | NaN | NaN | NaN | NaN | Electronic Control | ProSmart Inverter Motor | 3.0 | Blue | 39733.0 | 02-03-2023 | 10.0 | 3.9 | Delhi | Amazon | 5.0 | Out of Stock | 120.0 | Positive | Not Returned | Delivered with damaged packaging. | Resolved | 28-08-2023 | Delhi | Voltas Table Top Dishwasher (Model_N299) | arjun_20 |
| 1 | PID251899 | Washing Machine | Top Load | Model_K244 | NaN | NaN | 6.5 | NaN | Fully-Automatic | ProSmart Inverter Motor | 3.0 | Silver | 56336.0 | 21-07-2022 | 10.0 | 4.2 | Delhi | Amazon | 25.0 | Out of Stock | 120.0 | Positive | Returned | Cooling issue after 2 months. | In Progress | 14-01-2024 | Chennai | Voltas Top Load Washing Machine (Model_K244) | sanjay219 |
| 2 | PID857398 | Air Conditioner | Inverter AC | Model_X75 | 2.0 | NaN | NaN | NaN | Inverter | Turbo Mode | 1.0 | Blue | 52924.0 | 24-02-2022 | 1.0 | 4.8 | Bangalore | Flipkart | 20.0 | In Stock | 12.0 | Positive | Not Returned | Delivered with damaged packaging. | Unresolved | 20-07-2023 | Bangalore | Voltas Inverter AC Air Conditioner (Model_X75) | nisha_buyer0 |
| 3 | PID934528 | Air Conditioner | Window AC | Model_X101 | 1.0 | NaN | NaN | NaN | Non-Inverter | Self Diagnosis | 3.0 | Grey | 19256.0 | 30-05-2024 | 2.0 | 4.4 | Hyderabad | Vijay Sales | 10.0 | Out of Stock | 24.0 | Neutral | Not Returned | Noisy operation at night. | Resolved | 13-01-2023 | Pune | Voltas Window AC Air Conditioner (Model_X101) | preeti_deals8 |
| 4 | PID952837 | Air Conditioner | Split AC | Model_Y128 | 1.0 | NaN | NaN | NaN | Non-Inverter | Turbo Mode | 3.0 | Black | 44924.0 | 17-03-2024 | NaN | 3.3 | Bangalore | Amazon | 5.0 | In Stock | 120.0 | Positive | Returned | Excellent performance. | Resolved | 18-10-2023 | Pune | Voltas Split AC Air Conditioner (Model_Y128) | swati.buyer01 |
| 5 | PID552702 | Refrigerator | Double Door | Model_U332 | NaN | 450.0 | NaN | NaN | Direct Cool | Active Fresh Blue Light | 1.0 | Grey | 29024.0 | 01-08-2022 | 10.0 | 3.1 | Kolkata | Flipkart | 30.0 | In Stock | 120.0 | Neutral | Not Returned | Excellent performance. | Resolved | 25-10-2023 | Chennai | Voltas Double Door Refrigerator (Model_U332) | sanjay_reviews74 |
| 6 | PID509633 | Water Dispenser | Bottom Loading | Model_W126 | NaN | 15.0 | NaN | NaN | Compressor Cooling | Hot, Normal & Cold | 5.0 | White | 80497.0 | NaN | 2.0 | 4.1 | Pune | Croma | 25.0 | In Stock | 24.0 | Negative | Not Returned | Delivered with damaged packaging. | Resolved | 20-07-2022 | Delhi | Voltas Bottom Loading Water Dispenser M(odel_W126) | ajay_zone42 |
| 7 | PID430190 | Washing Machine | Top Load | Model_B495 | NaN | NaN | 6.5 | NaN | Semi-Automatic | GentleWave Drum | NaN | Grey | 13928.0 | 20-06-2023 | 10.0 | 4.5 | Bangalore | Vijay Sales | 20.0 | Out of Stock | 120.0 | Negative | Returned | Remote stopped working. | Resolved | 21-08-2022 | Pune | Voltas Top LoadW ashing Machine (Model_B495) | vinod9 |
| 8 | PID482549 | NaN | Split AC | Model_K166 | 1.0 | NaN | NaN | NaN | Non-Inverter | Turbo Mode | 4.0 | Silver | 18262.0 | 05-12-2023 | 5.0 | 3.4 | Bangalore | Amazon | 5.0 | Out of Stock | 60.0 | Neutral | Returned | No issues so far. | Unresolved | 09-11-2022 | Mumbai | NaN | radha_151 |
| 9 | PID164915 | Water Dispenser | Bottom Loading | Model_Y440 | NaN | 20.0 | NaN | NaN | Compressor Cooling | Hot & Cold | 5.0 | Black | 47034.0 | 25-08-2023 | 5.0 | 4.9 | Bangalore | Flipkart | 20.0 | Out of Stock | 60.0 | Neutral | Not Returned | Slow installation service. | In Progress | 01-06-2024 | Delhi | Voltas Bottom Loading Water Dispenser (Model_Y440) | radhaindia70 |
| product_id | product_category | sub_type | model_name | capacity_tons | capacity_liters | capacity_kg | capacity_place_settings | technology | feature_1 | energy_rating_stars | color | price_inr | manufacturing_date | warranty_years | customer_rating | city | platform | discount_offered | availability | warranty_duration_months | review_sentiment | return_status | complaint_text | resolved_status | review_date | reviewer_location | product_name | username | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 490 | PID445336 | Air Cooler | Desert | Model_L193 | NaN | 50.0 | NaN | NaN | Evaporative Cooling | Remote Control | 3.0 | Grey | 18654.0 | 13-05-2023 | 1.0 | 4.9 | Hyderabad | Amazon | 15.0 | Out of Stock | 12.0 | NaN | Returned | Delivered with damaged packaging. | In Progress | 12-10-2023 | Pune | Voltas Desert Air Cooler (Model_L193) | suresh.91 |
| 491 | PID108644 | Air Conditioner | Inverter AC | Model_C2 | 1.0 | NaN | NaN | NaN | Inverter | Turbo Mode | 4.0 | Silver | 55135.0 | 04-08-2023 | 5.0 | 5.0 | Hyderabad | Amazon | 25.0 | Out of Stock | 60.0 | Positive | Not Returned | Delivered with damaged packaging. | Resolved | NaN | Mumbai | Voltas Inverter AC Air Conditioner (Model_C2) | ajay7 |
| 492 | PID878002 | Refrigerator | NaN | Model_F317 | NaN | 250.0 | NaN | NaN | Direct Cool | StoreFresh+ | 1.0 | Black | 61806.0 | 31-01-2022 | 1.0 | 4.0 | Pune | Flipkart | 0.0 | Out of Stock | 12.0 | Neutral | Returned | Remote stopped working. | In Progress | 09-07-2022 | Hyderabad | Voltas Single Door Refrigerator (Model_F317) | deepa.zone5 |
| 493 | PID275253 | Refrigerator | Single Door | Model_Z129 | NaN | NaN | NaN | NaN | Frost Free | StoreFresh+ | 5.0 | Black | 56407.0 | 16-06-2024 | 2.0 | 3.1 | Kolkata | Croma | 15.0 | Out of Stock | 24.0 | Neutral | Not Returned | Remote stopped working. | Resolved | 28-03-2022 | Hyderabad | Voltas Single Door Refrigerator (Model_Z129) | vikasexpress2 |
| 494 | PID322665 | Air Conditioner | Split AC | Model_B131 | 1.0 | NaN | NaN | NaN | NaN | Adjustable Cooling | 3.0 | Grey | 67872.0 | 07-05-2023 | 10.0 | 4.1 | Hyderabad | Croma | 10.0 | Out of Stock | 120.0 | Negative | Returned | No issues so far. | Unresolved | 01-03-2022 | Ahmedabad | Voltas Split AC Air Conditioner (Model_B131) | deepa85 |
| 495 | PID408384 | Air Cooler | Desert | Model_R303 | NaN | 90.0 | NaN | NaN | Evaporative Cooling | Ice Chamber | 5.0 | White | NaN | 03-03-2022 | 10.0 | 3.2 | Chennai | Flipkart | 10.0 | Out of Stock | 120.0 | Positive | Returned | Noisy operation at night. | In Progress | 11-03-2023 | Mumbai | Voltas Desert Air Cooler (Model_R303) | seema.buyer22 |
| 496 | PID319590 | Washing Machine | Top Load | Model_N221 | NaN | NaN | 6.0 | NaN | Semi-Automatic | ProSmart Inverter Motor | 2.0 | Blue | 19647.0 | 23-06-2022 | 2.0 | 3.2 | Chennai | Amazon | 0.0 | Out of Stock | 24.0 | Negative | Returned | Excellent performance. | In Progress | 09-11-2023 | Hyderabad | Voltas Top Load Washing Machine (Model_N221) | shilpa767 |
| 497 | PID390184 | Dishwasher | Full Size | NaN | NaN | NaN | NaN | 12.0 | Electronic Control | Hygiene+ | 5.0 | Grey | 14754.0 | 28-08-2022 | 10.0 | 4.5 | Mumbai | Vijay Sales | 20.0 | Out of Stock | 120.0 | Positive | Not Returned | Cooling issue after 2 months. | In Progress | 30-06-2022 | Hyderabad | Voltas Full Size Dishwasher (Model_W230) | rohitzone84 |
| 498 | PID966079 | Washing Machine | Front Load | Model_S96 | NaN | NaN | 6.0 | NaN | Fully-Automatic | ProSmart Inverter Motor | 3.0 | White | 58325.0 | 19-01-2023 | 1.0 | 4.8 | Pune | Croma | 30.0 | In Stock | 12.0 | Negative | Returned | Excellent performance. | Resolved | 21-06-2022 | Hyderabad | Voltas Front Load Washing Machine (Model_S96) | nisha_52 |
| 499 | PID937912 | Dishwasher | Full Size | Model_T175 | NaN | NaN | NaN | 12.0 | Electronic Control | ProSmart Inverter Motor | 4.0 | Black | 71284.0 | 13-12-2023 | 10.0 | 4.2 | Pune | Croma | 0.0 | In Stock | 120.0 | Negative | Returned | Slow installation service. | Resolved | 12-01-2024 | Ahmedabad | Voltas Full Size Dishwasher (Model_T175) | komal.shop392 |